/*
 Navicat Premium Data Transfer

 Source Server         : 172.16.24.150
 Source Server Type    : MySQL
 Source Server Version : 50727
 Source Host           : 172.16.24.150:3306
 Source Schema         : viewer

 Target Server Type    : MySQL
 Target Server Version : 50727
 File Encoding         : 65001

 Date: 24/10/2020 12:36:48
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for Province
-- ----------------------------
DROP TABLE IF EXISTS `Province`;
CREATE TABLE `Province` (
  `ProvinceID` int(11) NOT NULL,
  `Name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ProvinceID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of Province
-- ----------------------------
BEGIN;
INSERT INTO `Province` VALUES (1, '北京');
INSERT INTO `Province` VALUES (2, '天津');
INSERT INTO `Province` VALUES (3, '上海');
INSERT INTO `Province` VALUES (4, '重庆');
INSERT INTO `Province` VALUES (5, '河北');
INSERT INTO `Province` VALUES (6, '山西');
INSERT INTO `Province` VALUES (7, '台湾');
INSERT INTO `Province` VALUES (8, '辽宁');
INSERT INTO `Province` VALUES (9, '吉林');
INSERT INTO `Province` VALUES (10, '黑龙江');
INSERT INTO `Province` VALUES (11, '江苏');
INSERT INTO `Province` VALUES (12, '浙江');
INSERT INTO `Province` VALUES (13, '安徽');
INSERT INTO `Province` VALUES (14, '福建');
INSERT INTO `Province` VALUES (15, '江西');
INSERT INTO `Province` VALUES (16, '山东');
INSERT INTO `Province` VALUES (17, '河南');
INSERT INTO `Province` VALUES (18, '湖北');
INSERT INTO `Province` VALUES (19, '湖南');
INSERT INTO `Province` VALUES (20, '广东');
INSERT INTO `Province` VALUES (21, '甘肃');
INSERT INTO `Province` VALUES (22, '四川');
INSERT INTO `Province` VALUES (23, '贵州');
INSERT INTO `Province` VALUES (24, '海南');
INSERT INTO `Province` VALUES (25, '云南');
INSERT INTO `Province` VALUES (26, '青海');
INSERT INTO `Province` VALUES (27, '陕西');
INSERT INTO `Province` VALUES (28, '广西');
INSERT INTO `Province` VALUES (29, '西藏');
INSERT INTO `Province` VALUES (30, '宁夏');
INSERT INTO `Province` VALUES (31, '新疆');
INSERT INTO `Province` VALUES (32, '内蒙古');
INSERT INTO `Province` VALUES (33, '澳门');
INSERT INTO `Province` VALUES (34, '香港');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
